train_df_final Data Summary Report

Dataset statistics

Number of variables	38
Number of observations	3240
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	822.8 KiB
Average record size in memory	260.0 B

Variable types

Numeric	24
Categorical	9
DateTime	5

Warnings

`msno` has a high cardinality: 3240 distinct values	High cardinality
`bd` is highly correlated with `gender`	High correlation
`gender` is highly correlated with `bd`	High correlation
`total_payment_channels` is highly correlated with `total_transactions` and 3 other fields	High correlation
`change_in_payment_methods` is highly correlated with `change_in_plan`	High correlation
`payment_plan_days_mean` is highly correlated with `plan_list_price_mean` and 1 other fields	High correlation
`change_in_plan` is highly correlated with `change_in_payment_methods`	High correlation
`plan_list_price_mean` is highly correlated with `payment_plan_days_mean` and 2 other fields	High correlation
`actual_amount_paid_mean` is highly correlated with `payment_plan_days_mean` and 2 other fields	High correlation
`is_auto_renew_mean` is highly correlated with `is_autorenew_change_flag`	High correlation
`is_autorenew_change_flag` is highly correlated with `is_auto_renew_mean`	High correlation
`total_transactions` is highly correlated with `total_payment_channels` and 3 other fields	High correlation
`is_cancel_mean` is highly correlated with `is_cancel_change_flag`	High correlation
`is_cancel_change_flag` is highly correlated with `is_cancel_mean`	High correlation
`discount_mean` is highly correlated with `is_discount_mean` and 1 other fields	High correlation
`is_discount_mean` is highly correlated with `discount_mean` and 1 other fields	High correlation
`is_discount_max` is highly correlated with `discount_mean` and 1 other fields	High correlation
`membership_duration_mean` is highly correlated with `plan_list_price_mean` and 1 other fields	High correlation
`more_than_30_sum` is highly correlated with `total_payment_channels` and 2 other fields	High correlation
`num_25` is highly correlated with `num_50` and 2 other fields	High correlation
`num_50` is highly correlated with `num_25` and 2 other fields	High correlation
`num_75` is highly correlated with `num_25` and 2 other fields	High correlation
`num_985` is highly correlated with `num_25` and 2 other fields	High correlation
`num_100` is highly correlated with `num_unq` and 1 other fields	High correlation
`num_unq` is highly correlated with `num_100` and 1 other fields	High correlation
`total_secs` is highly correlated with `num_100` and 1 other fields	High correlation
`login_freq` is highly correlated with `total_payment_channels` and 2 other fields	High correlation
`registration_duration` is highly correlated with `total_payment_channels` and 3 other fields	High correlation
`bd` is highly correlated with `gender`	High correlation
`gender` is highly correlated with `bd`	High correlation
`total_payment_channels` is highly correlated with `total_transactions` and 3 other fields	High correlation
`change_in_payment_methods` is highly correlated with `change_in_plan` and 1 other fields	High correlation
`change_in_plan` is highly correlated with `change_in_payment_methods`	High correlation
`plan_list_price_mean` is highly correlated with `actual_amount_paid_mean` and 2 other fields	High correlation
`actual_amount_paid_mean` is highly correlated with `plan_list_price_mean` and 2 other fields	High correlation
`is_auto_renew_mean` is highly correlated with `change_in_payment_methods` and 3 other fields	High correlation
`is_autorenew_change_flag` is highly correlated with `is_auto_renew_mean`	High correlation
`total_transactions` is highly correlated with `total_payment_channels` and 3 other fields	High correlation
`is_cancel_mean` is highly correlated with `is_cancel_change_flag`	High correlation
`is_cancel_change_flag` is highly correlated with `is_cancel_mean`	High correlation
`discount_mean` is highly correlated with `is_discount_mean` and 1 other fields	High correlation
`is_discount_mean` is highly correlated with `discount_mean` and 1 other fields	High correlation
`is_discount_max` is highly correlated with `discount_mean` and 1 other fields	High correlation
`amt_per_day_mean` is highly correlated with `plan_list_price_mean` and 1 other fields	High correlation
`more_than_30_sum` is highly correlated with `total_payment_channels` and 2 other fields	High correlation
`num_25` is highly correlated with `num_50` and 2 other fields	High correlation
`num_50` is highly correlated with `num_25` and 2 other fields	High correlation
`num_75` is highly correlated with `num_25` and 2 other fields	High correlation
`num_985` is highly correlated with `num_25` and 2 other fields	High correlation
`num_100` is highly correlated with `num_unq` and 1 other fields	High correlation
`num_unq` is highly correlated with `num_100` and 1 other fields	High correlation
`total_secs` is highly correlated with `num_100` and 1 other fields	High correlation
`login_freq` is highly correlated with `total_payment_channels` and 2 other fields	High correlation
`registration_duration` is highly correlated with `total_payment_channels` and 3 other fields	High correlation
`bd` is highly correlated with `gender`	High correlation
`gender` is highly correlated with `bd`	High correlation
`total_payment_channels` is highly correlated with `total_transactions` and 2 other fields	High correlation
`change_in_payment_methods` is highly correlated with `change_in_plan` and 1 other fields	High correlation
`change_in_plan` is highly correlated with `change_in_payment_methods`	High correlation
`plan_list_price_mean` is highly correlated with `actual_amount_paid_mean` and 2 other fields	High correlation
`actual_amount_paid_mean` is highly correlated with `plan_list_price_mean` and 2 other fields	High correlation
`is_auto_renew_mean` is highly correlated with `change_in_payment_methods` and 3 other fields	High correlation
`is_autorenew_change_flag` is highly correlated with `is_auto_renew_mean`	High correlation
`total_transactions` is highly correlated with `total_payment_channels` and 2 other fields	High correlation
`is_cancel_mean` is highly correlated with `is_cancel_change_flag`	High correlation
`is_cancel_change_flag` is highly correlated with `is_cancel_mean`	High correlation
`discount_mean` is highly correlated with `is_discount_mean` and 1 other fields	High correlation
`is_discount_mean` is highly correlated with `discount_mean` and 1 other fields	High correlation
`is_discount_max` is highly correlated with `discount_mean` and 1 other fields	High correlation
`amt_per_day_mean` is highly correlated with `plan_list_price_mean` and 1 other fields	High correlation
`more_than_30_sum` is highly correlated with `total_payment_channels` and 1 other fields	High correlation
`num_25` is highly correlated with `num_50`	High correlation
`num_50` is highly correlated with `num_25` and 1 other fields	High correlation
`num_75` is highly correlated with `num_50` and 1 other fields	High correlation
`num_985` is highly correlated with `num_75`	High correlation
`num_100` is highly correlated with `num_unq` and 1 other fields	High correlation
`num_unq` is highly correlated with `num_100` and 1 other fields	High correlation
`total_secs` is highly correlated with `num_100` and 1 other fields	High correlation
`registration_duration` is highly correlated with `total_payment_channels` and 1 other fields	High correlation
`change_in_plan` is highly correlated with `total_transactions` and 4 other fields	High correlation
`amt_per_day_mean` is highly correlated with `total_transactions` and 11 other fields	High correlation
`city` is highly correlated with `bd` and 2 other fields	High correlation
`total_transactions` is highly correlated with `change_in_plan` and 5 other fields	High correlation
`is_autorenew_change_flag` is highly correlated with `is_churn` and 3 other fields	High correlation
`is_churn` is highly correlated with `is_autorenew_change_flag` and 1 other fields	High correlation
`bd` is highly correlated with `city` and 2 other fields	High correlation
`is_auto_renew_mean` is highly correlated with `change_in_plan` and 3 other fields	High correlation
`payment_plan_days_mean` is highly correlated with `amt_per_day_mean` and 4 other fields	High correlation
`change_in_payment_methods` is highly correlated with `is_auto_renew_mean`	High correlation
`total_payment_channels` is highly correlated with `change_in_plan` and 5 other fields	High correlation
`num_985` is highly correlated with `num_50` and 2 other fields	High correlation
`is_cancel_change_flag` is highly correlated with `is_cancel_mean` and 1 other fields	High correlation
`is_cancel_mean` is highly correlated with `amt_per_day_mean` and 3 other fields	High correlation
`num_50` is highly correlated with `num_985` and 2 other fields	High correlation
`num_75` is highly correlated with `num_985` and 3 other fields	High correlation
`is_discount_max` is highly correlated with `amt_per_day_mean` and 3 other fields	High correlation
`membership_expire_date_max` is highly correlated with `amt_per_day_mean` and 5 other fields	High correlation
`login_freq` is highly correlated with `total_transactions` and 2 other fields	High correlation
`gender` is highly correlated with `amt_per_day_mean` and 2 other fields	High correlation
`plan_list_price_mean` is highly correlated with `amt_per_day_mean` and 4 other fields	High correlation
`registration_duration` is highly correlated with `change_in_plan` and 5 other fields	High correlation
`is_discount_mean` is highly correlated with `amt_per_day_mean` and 3 other fields	High correlation
`num_25` is highly correlated with `num_985` and 3 other fields	High correlation
`total_secs` is highly correlated with `num_unq` and 1 other fields	High correlation
`more_than_30_sum` is highly correlated with `total_transactions` and 4 other fields	High correlation
`actual_amount_paid_mean` is highly correlated with `amt_per_day_mean` and 4 other fields	High correlation
`num_unq` is highly correlated with `num_75` and 3 other fields	High correlation
`membership_duration_mean` is highly correlated with `payment_plan_days_mean` and 2 other fields	High correlation
`discount_mean` is highly correlated with `amt_per_day_mean` and 3 other fields	High correlation
`registered_via` is highly correlated with `change_in_plan` and 6 other fields	High correlation
`num_100` is highly correlated with `total_secs` and 1 other fields	High correlation
`is_autorenew_change_flag` is highly correlated with `registered_via`	High correlation
`registered_via` is highly correlated with `is_autorenew_change_flag`	High correlation
`membership_duration_mean` is highly skewed (γ1 = -31.16723676)	Skewed
`msno` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`msno` has unique values	Unique
`is_auto_renew_mean` has 487 (15.0%) zeros	Zeros
`is_cancel_mean` has 2770 (85.5%) zeros	Zeros
`discount_mean` has 2911 (89.8%) zeros	Zeros
`is_discount_mean` has 3026 (93.4%) zeros	Zeros
`more_than_30_sum` has 428 (13.2%) zeros	Zeros
`num_25` has 134 (4.1%) zeros	Zeros
`num_50` has 556 (17.2%) zeros	Zeros
`num_75` has 844 (26.0%) zeros	Zeros
`num_985` has 815 (25.2%) zeros	Zeros
`num_100` has 41 (1.3%) zeros	Zeros

Reproduction

Analysis started	2023-05-19 10:59:18.921773
Analysis finished	2023-05-19 11:00:38.432253
Duration	1 minute and 19.51 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	3240
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	161888.8309

Minimum	14
Maximum	323987
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	14
5-th percentile	15865.25
Q1	80864.5
median	161963
Q3	244588
95-th percentile	307726.4
Maximum	323987
Range	323973
Interquartile range (IQR)	163723.5

Descriptive statistics

Standard deviation	94433.52726
Coefficient of variation (CV)	0.5833233013
Kurtosis	-1.224760133
Mean	161888.8309
Median Absolute Deviation (MAD)	81636
Skewness	0.006914496358
Sum	524519812
Variance	8917691071
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
252737	1	< 0.1%
160338	1	< 0.1%
143945	1	< 0.1%
283395	1	< 0.1%
98262	1	< 0.1%
117828	1	< 0.1%
288532	1	< 0.1%
17270	1	< 0.1%
53987	1	< 0.1%
67522	1	< 0.1%
Other values (3230)	3230	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
14	1	< 0.1%
70	1	< 0.1%
123	1	< 0.1%
126	1	< 0.1%
183	1	< 0.1%
300	1	< 0.1%
316	1	< 0.1%
361	1	< 0.1%
393	1	< 0.1%
454	1	< 0.1%

Value	Count	Frequency (%)
323987	1	< 0.1%
323798	1	< 0.1%
323743	1	< 0.1%
323717	1	< 0.1%
323665	1	< 0.1%
323461	1	< 0.1%
323388	1	< 0.1%
323370	1	< 0.1%
323348	1	< 0.1%
323329	1	< 0.1%

msno
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	3240
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	25.4 KiB

T4TLe/jOIP0/Bg9kOKR3rd19XVZDIHlVzvS3DhpweIk=	1
oYyjgI3EMtpJamxLBTROcYLXR3spcB/4zXrqtTQFM74=	1
6y0f6LY1AXh1qAI68f0faAKjgU/DPp+j63xTnsmdtT4=	1
hsR0Pfz3iJtzva17DoxOqq20i4WfYFKLN/wgT914vrI=	1
ZQbQiWQgoyPDP/cYkgDC0tCzFIjjBKIEEiU3/YGApMo=	1
Other values (3235)	3235

Length

Max length	44
Median length	44
Mean length	44
Min length	44

Characters and Unicode

Total characters	142560
Distinct characters	65
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3240 ?
Unique (%)	100.0%

Sample

1st row	T4TLe/jOIP0/Bg9kOKR3rd19XVZDIHlVzvS3DhpweIk=
2nd row	3twUh3ugQEnQyGAyOxT4uPhpMht2EPW1vl6/k7J+RdI=
3rd row	/1X44AKG3S5AoBAJeokIkqLvgRaz+h5ElPncLqWnWys=
4th row	1Ufg2Ep/dzom8G0hN+0UWbmxpRPFrGt4D4Vh2yd4pOA=
5th row	ZozytlgZZhHBVCTHGug8CxREhiV9QpS+TJ5e+z06gVA=

Common Values

Value	Count	Frequency (%)
T4TLe/jOIP0/Bg9kOKR3rd19XVZDIHlVzvS3DhpweIk=	1	< 0.1%
oYyjgI3EMtpJamxLBTROcYLXR3spcB/4zXrqtTQFM74=	1	< 0.1%
6y0f6LY1AXh1qAI68f0faAKjgU/DPp+j63xTnsmdtT4=	1	< 0.1%
hsR0Pfz3iJtzva17DoxOqq20i4WfYFKLN/wgT914vrI=	1	< 0.1%
ZQbQiWQgoyPDP/cYkgDC0tCzFIjjBKIEEiU3/YGApMo=	1	< 0.1%
E/+UHeBM49ngCPpd/Vaw/sYP6TaFVVdtzcUJ7gvMppc=	1	< 0.1%
Z3a78s0yd2RKBmzbbgZSL3hHHiFou4XHmgrto98NZu8=	1	< 0.1%
wiRcrrJmtHIk2yF1dRiDYq+EI9womxMzPoJuxEW/jys=	1	< 0.1%
qgeZDGVoBbyOgBRcWv9H8RoJ/XJTnSgoPw4+3Amuvx0=	1	< 0.1%
C0Pz1O2940qoI4iHBIdQdZtYdTKn9u/8kJy3AAGhESc=	1	< 0.1%
Other values (3230)	3230	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
t4tle/joip0/bg9kokr3rd19xvzdihlvzvs3dhpweik	1	< 0.1%
oyyjgi3emtpjamxlbtrocylxr3spcb/4zxrqttqfm74	1	< 0.1%
6y0f6ly1axh1qai68f0faakjgu/dpp+j63xtnsmdtt4	1	< 0.1%
hsr0pfz3ijtzva17doxoqq20i4wfyfkln/wgt914vri	1	< 0.1%
zqbqiwqgoypdp/cykgdc0tczfijjbkieeiu3/ygapmo	1	< 0.1%
e/+uhebm49ngcppd/vaw/syp6tafvvdtzcuj7gvmppc	1	< 0.1%
z3a78s0yd2rkbmzbbgzsl3hhhifou4xhmgrto98nzu8	1	< 0.1%
wircrrjmthik2yf1dridyq+ei9womxmzpojuxew/jys	1	< 0.1%
qgezdgvobbyogbrcwv9h8roj/xjtnsgopw4+3amuvx0	1	< 0.1%
c0pz1o2940qoi4ihbidqdztydtkn9u/8kjy3aaghesc	1	< 0.1%
Other values (3230)	3230	99.7%

Most occurring characters

Value	Count	Frequency (%)
=	3240	2.3%
I	2427	1.7%
0	2389	1.7%
A	2370	1.7%
g	2358	1.7%
s	2351	1.6%
c	2349	1.6%
8	2335	1.6%
Q	2333	1.6%
E	2333	1.6%
Other values (55)	118075	82.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	56582	39.7%
Lowercase Letter	56288	39.5%
Decimal Number	22086	15.5%
Math Symbol	5462	3.8%
Other Punctuation	2142	1.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	2427	4.3%
A	2370	4.2%
Q	2333	4.1%
E	2333	4.1%
M	2319	4.1%
Y	2313	4.1%
U	2252	4.0%
W	2170	3.8%
Z	2169	3.8%
H	2158	3.8%
Other values (16)	33738	59.6%

Lowercase Letter

Value	Count	Frequency (%)
g	2358	4.2%
s	2351	4.2%
c	2349	4.2%
o	2305	4.1%
w	2294	4.1%
k	2264	4.0%
m	2225	4.0%
p	2207	3.9%
b	2167	3.8%
e	2162	3.8%
Other values (16)	33606	59.7%

Decimal Number

Value	Count	Frequency (%)
0	2389	10.8%
8	2335	10.6%
4	2279	10.3%
5	2191	9.9%
2	2181	9.9%
6	2159	9.8%
3	2156	9.8%
9	2145	9.7%
1	2133	9.7%
7	2118	9.6%

Math Symbol

Value	Count	Frequency (%)
=	3240	59.3%
+	2222	40.7%

Other Punctuation

Value	Count	Frequency (%)
/	2142	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	112870	79.2%
Common	29690	20.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	2427	2.2%
A	2370	2.1%
g	2358	2.1%
s	2351	2.1%
c	2349	2.1%
Q	2333	2.1%
E	2333	2.1%
M	2319	2.1%
Y	2313	2.0%
o	2305	2.0%
Other values (42)	89412	79.2%

Common

Value	Count	Frequency (%)
=	3240	10.9%
0	2389	8.0%
8	2335	7.9%
4	2279	7.7%
+	2222	7.5%
5	2191	7.4%
2	2181	7.3%
6	2159	7.3%
3	2156	7.3%
9	2145	7.2%
Other values (3)	6393	21.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	142560	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
=	3240	2.3%
I	2427	1.7%
0	2389	1.7%
A	2370	1.7%
g	2358	1.7%
s	2351	1.6%
c	2349	1.6%
8	2335	1.6%
Q	2333	1.6%
E	2333	1.6%
Other values (55)	118075	82.8%

city
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	19
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.179012346

Minimum	1
Maximum	22
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	5
95-th percentile	17
Maximum	22
Range	21
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	5.782679871
Coefficient of variation (CV)	1.383743189
Kurtosis	1.974860602
Mean	4.179012346
Median Absolute Deviation (MAD)	0
Skewness	1.773794867
Sum	13540
Variance	33.43938649
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
1	2228	68.8%
13	203	6.3%
5	179	5.5%
4	131	4.0%
22	119	3.7%
15	109	3.4%
6	55	1.7%
14	54	1.7%
11	21	0.6%
18	21	0.6%
Other values (9)	120	3.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2228	68.8%
3	19	0.6%
4	131	4.0%
5	179	5.5%
6	55	1.7%
7	2	0.1%
8	16	0.5%
9	20	0.6%
10	15	0.5%
11	21	0.6%

Value	Count	Frequency (%)
22	119	3.7%
21	17	0.5%
18	21	0.6%
17	8	0.2%
16	2	0.1%
15	109	3.4%
14	54	1.7%
13	203	6.3%
12	21	0.6%
11	21	0.6%

bd
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	48
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.23395062

Minimum	6.3
Maximum	64
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	6.3
5-th percentile	6.3
Q1	6.3
median	6.3
Q3	19
95-th percentile	34
Maximum	64
Range	57.7
Interquartile range (IQR)	12.7

Descriptive statistics

Standard deviation	10.34671505
Coefficient of variation (CV)	0.8457378466
Kurtosis	2.158231595
Mean	12.23395062
Median Absolute Deviation (MAD)	0
Skewness	1.66947139
Sum	39638
Variance	107.0545123
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
6.3	2310	71.3%
22	67	2.1%
21	58	1.8%
27	57	1.8%
20	57	1.8%
25	55	1.7%
24	54	1.7%
23	53	1.6%
26	51	1.6%
19	48	1.5%
Other values (38)	430	13.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6.3	2310	71.3%
7	1	< 0.1%
14	2	0.1%
15	3	0.1%
16	9	0.3%
17	34	1.0%
18	44	1.4%
19	48	1.5%
20	57	1.8%
21	58	1.8%

Value	Count	Frequency (%)
64	1	< 0.1%
61	1	< 0.1%
58	1	< 0.1%
57	2	0.1%
56	2	0.1%
54	2	0.1%
53	4	0.1%
52	5	0.2%
51	2	0.1%
50	4	0.1%

gender
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	25.4 KiB

2	2297
0	502
1	441

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	3240
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	1
3rd row	2
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
2	2297	70.9%
0	502	15.5%
1	441	13.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2	2297	70.9%
0	502	15.5%
1	441	13.6%

Most occurring characters

Value	Count	Frequency (%)
2	2297	70.9%
0	502	15.5%
1	441	13.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3240	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	2297	70.9%
0	502	15.5%
1	441	13.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	3240	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	2297	70.9%
0	502	15.5%
1	441	13.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3240	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	2297	70.9%
0	502	15.5%
1	441	13.6%

registered_via
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	25.4 KiB

7	2085
4	461
9	387
3	281
13	26

Length

Max length	2
Median length	1
Mean length	1.008024691
Min length	1

Characters and Unicode

Total characters	3266
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	3
3rd row	7
4th row	7
5th row	7

Common Values

Value	Count	Frequency (%)
7	2085	64.4%
4	461	14.2%
9	387	11.9%
3	281	8.7%
13	26	0.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
7	2085	64.4%
4	461	14.2%
9	387	11.9%
3	281	8.7%
13	26	0.8%

Most occurring characters

Value	Count	Frequency (%)
7	2085	63.8%
4	461	14.1%
9	387	11.8%
3	307	9.4%
1	26	0.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3266	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
7	2085	63.8%
4	461	14.1%
9	387	11.8%
3	307	9.4%
1	26	0.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	3266	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
7	2085	63.8%
4	461	14.1%
9	387	11.8%
3	307	9.4%
1	26	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3266	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
7	2085	63.8%
4	461	14.1%
9	387	11.8%
3	307	9.4%
1	26	0.8%

registration_init_time
Date

Distinct	729
Distinct (%)	22.5%
Missing	0
Missing (%)	0.0%
Memory size	25.4 KiB

Minimum	2015-01-01 00:00:00
Maximum	2017-02-07 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

is_churn
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	25.4 KiB

0	3029
1	211

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	3240
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	3029	93.5%
1	211	6.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	3029	93.5%
1	211	6.5%

Most occurring characters

Value	Count	Frequency (%)
0	3029	93.5%
1	211	6.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3240	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	3029	93.5%
1	211	6.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	3240	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	3029	93.5%
1	211	6.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3240	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	3029	93.5%
1	211	6.5%

total_payment_channels
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.79444444

Minimum	1
Maximum	36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	7
median	12
Q3	17
95-th percentile	22
Maximum	36
Range	35
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	6.115061702
Coefficient of variation (CV)	0.5184696686
Kurtosis	-0.7101382253
Mean	11.79444444
Median Absolute Deviation (MAD)	5
Skewness	0.2016205715
Sum	38214
Variance	37.39397962
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
8	212	6.5%
17	207	6.4%
14	207	6.4%
9	201	6.2%
13	176	5.4%
16	175	5.4%
7	173	5.3%
3	167	5.2%
18	162	5.0%
12	157	4.8%
Other values (21)	1403	43.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	38	1.2%
2	120	3.7%
3	167	5.2%
4	147	4.5%
5	132	4.1%
6	139	4.3%
7	173	5.3%
8	212	6.5%
9	201	6.2%
10	133	4.1%

Value	Count	Frequency (%)
36	1	< 0.1%
32	2	0.1%
29	2	0.1%
28	2	0.1%
27	10	0.3%
26	20	0.6%
25	24	0.7%
24	42	1.3%
23	39	1.2%
22	34	1.0%

change_in_payment_methods
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	25.4 KiB

1	2843
2	326
3	67
4	4

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	3240
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	2843	87.7%
2	326	10.1%
3	67	2.1%
4	4	0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	2843	87.7%
2	326	10.1%
3	67	2.1%
4	4	0.1%

Most occurring characters

Value	Count	Frequency (%)
1	2843	87.7%
2	326	10.1%
3	67	2.1%
4	4	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3240	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	2843	87.7%
2	326	10.1%
3	67	2.1%
4	4	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	3240	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	2843	87.7%
2	326	10.1%
3	67	2.1%
4	4	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3240	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	2843	87.7%
2	326	10.1%
3	67	2.1%
4	4	0.1%

payment_plan_days_mean
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	190
Distinct (%)	5.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.6291838

Minimum	14.55555556
Maximum	450
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	14.55555556
5-th percentile	28.63636364
Q1	30
median	30
Q3	30
95-th percentile	35.16043956
Maximum	450
Range	435.4444444
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	28.03768047
Coefficient of variation (CV)	0.8337306262
Kurtosis	128.6321562
Mean	33.6291838
Median Absolute Deviation (MAD)	0
Skewness	10.63379202
Sum	108958.5555
Variance	786.111526
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	2783	85.9%
28.75	21	0.6%
24.25	18	0.6%
28.69565217	18	0.6%
28.63636364	14	0.4%
28.8	11	0.3%
45	11	0.3%
25.4	11	0.3%
410	10	0.3%
28.84615385	8	0.2%
Other values (180)	335	10.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
14.55555556	1	< 0.1%
18.5	2	0.1%
20.14285714	1	< 0.1%
20.8	1	< 0.1%
21.81818182	1	< 0.1%
22.17391304	3	0.1%
22.33333333	5	0.2%
23.18181818	2	0.1%
24.25	18	0.6%
24.28571429	1	< 0.1%

Value	Count	Frequency (%)
450	1	< 0.1%
410	10	0.3%
377.5	1	< 0.1%
265	1	< 0.1%
240	1	< 0.1%
220	2	0.1%
205	1	< 0.1%
200	3	0.1%
195	7	0.2%
180	3	0.1%

change_in_plan
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	25.4 KiB

1	2818
2	344
3	72
4	5
5	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	3240
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	2
2nd row	2
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	2818	87.0%
2	344	10.6%
3	72	2.2%
4	5	0.2%
5	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	2818	87.0%
2	344	10.6%
3	72	2.2%
4	5	0.2%
5	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	2818	87.0%
2	344	10.6%
3	72	2.2%
4	5	0.2%
5	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3240	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	2818	87.0%
2	344	10.6%
3	72	2.2%
4	5	0.2%
5	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	3240	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	2818	87.0%
2	344	10.6%
3	72	2.2%
4	5	0.2%
5	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3240	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	2818	87.0%
2	344	10.6%
3	72	2.2%
4	5	0.2%
5	1	< 0.1%

plan_list_price_mean
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	474
Distinct (%)	14.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	139.228954

Minimum	0
Maximum	1788
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	0
5-th percentile	99
Q1	99
median	110.1304348
Q3	149
95-th percentile	180
Maximum	1788
Range	1788
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	119.4715099
Coefficient of variation (CV)	0.858093855
Kurtosis	122.3844121
Mean	139.228954
Median Absolute Deviation (MAD)	11.13043478
Skewness	10.04625679
Sum	451101.811
Variance	14273.44168
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99	1502	46.4%
149	658	20.3%
180	148	4.6%
129	50	1.5%
100	30	0.9%
142.7916667	22	0.7%
143.04	13	0.4%
142.2272727	11	0.3%
111.75	11	0.3%
150	11	0.3%
Other values (464)	784	24.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
53.33333333	1	< 0.1%
74.5	1	< 0.1%
75	1	< 0.1%
85.14285714	1	< 0.1%
89.4	1	< 0.1%
90	1	< 0.1%
92.875	1	< 0.1%
93.17647059	1	< 0.1%
94	1	< 0.1%

Value	Count	Frequency (%)
1788	10	0.3%
1399.5	1	< 0.1%
1132.5	1	< 0.1%
984	1	< 0.1%
958.5	1	< 0.1%
930	3	0.1%
894	6	0.2%
799.5	1	< 0.1%
716	1	< 0.1%
695.3333333	1	< 0.1%

actual_amount_paid_mean
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	492
Distinct (%)	15.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	138.4574094

Minimum	0
Maximum	1788
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	0
5-th percentile	99
Q1	99
median	102.3666667
Q3	149
95-th percentile	180
Maximum	1788
Range	1788
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	119.6452441
Coefficient of variation (CV)	0.8641303095
Kurtosis	121.8451475
Mean	138.4574094
Median Absolute Deviation (MAD)	12.58525641
Skewness	10.01005139
Sum	448602.0066
Variance	14314.98443
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99	1502	46.4%
149	671	20.7%
180	147	4.5%
129	51	1.6%
100	30	0.9%
111.75	14	0.4%
150	11	0.3%
132.4444444	11	0.3%
1788	10	0.3%
175	9	0.3%
Other values (482)	784	24.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
49.66666667	1	< 0.1%
53.33333333	1	< 0.1%
59.6	1	< 0.1%
60	1	< 0.1%
64.5	1	< 0.1%
66	2	0.1%
74.25	4	0.1%
74.5	5	0.2%
75	1	< 0.1%

Value	Count	Frequency (%)
1788	10	0.3%
1399.5	1	< 0.1%
1132.5	1	< 0.1%
984	1	< 0.1%
958.5	1	< 0.1%
930	3	0.1%
894	6	0.2%
799.5	1	< 0.1%
716	1	< 0.1%
690	1	< 0.1%

is_auto_renew_mean
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	78
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.8247552119

Minimum	0
Maximum	1
Zeros	487
Zeros (%)	15.0%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3631098106
Coefficient of variation (CV)	0.4402637356
Kurtosis	1.140655052
Mean	0.8247552119
Median Absolute Deviation (MAD)	0
Skewness	-1.734857511
Sum	2672.206887
Variance	0.1318487345
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2513	77.6%
0	487	15.0%
0.75	20	0.6%
0.6666666667	17	0.5%
0.5	14	0.4%
0.8888888889	10	0.3%
0.8571428571	9	0.3%
0.9	9	0.3%
0.8	9	0.3%
0.875	9	0.3%
Other values (68)	143	4.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	487	15.0%
0.05	1	< 0.1%
0.08333333333	1	< 0.1%
0.1333333333	1	< 0.1%
0.1538461538	1	< 0.1%
0.1666666667	5	0.2%
0.1818181818	1	< 0.1%
0.1875	1	< 0.1%
0.2	2	0.1%
0.2142857143	1	< 0.1%

Value	Count	Frequency (%)
1	2513	77.6%
0.9583333333	1	< 0.1%
0.9545454545	1	< 0.1%
0.9523809524	1	< 0.1%
0.95	2	0.1%
0.9473684211	2	0.1%
0.9444444444	1	< 0.1%
0.9411764706	4	0.1%
0.9375	3	0.1%
0.9285714286	2	0.1%

is_autorenew_change_flag
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	25.4 KiB

1	2753
0	487

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	3240
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	2753	85.0%
0	487	15.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	2753	85.0%
0	487	15.0%

Most occurring characters

Value	Count	Frequency (%)
1	2753	85.0%
0	487	15.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3240	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	2753	85.0%
0	487	15.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3240	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	2753	85.0%
0	487	15.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3240	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	2753	85.0%
0	487	15.0%

transaction_date_min
Date

Distinct	721
Distinct (%)	22.3%
Missing	0
Missing (%)	0.0%
Memory size	25.4 KiB

Minimum	2015-01-01 00:00:00
Maximum	2017-02-17 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

transaction_date_max
Date

Distinct	121
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Memory size	25.4 KiB

Minimum	2015-11-24 00:00:00
Maximum	2017-02-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

total_transactions
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.79444444

Minimum	1
Maximum	36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	7
median	12
Q3	17
95-th percentile	22
Maximum	36
Range	35
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	6.115061702
Coefficient of variation (CV)	0.5184696686
Kurtosis	-0.7101382253
Mean	11.79444444
Median Absolute Deviation (MAD)	5
Skewness	0.2016205715
Sum	38214
Variance	37.39397962
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
8	212	6.5%
17	207	6.4%
14	207	6.4%
9	201	6.2%
13	176	5.4%
16	175	5.4%
7	173	5.3%
3	167	5.2%
18	162	5.0%
12	157	4.8%
Other values (21)	1403	43.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	38	1.2%
2	120	3.7%
3	167	5.2%
4	147	4.5%
5	132	4.1%
6	139	4.3%
7	173	5.3%
8	212	6.5%
9	201	6.2%
10	133	4.1%

Value	Count	Frequency (%)
36	1	< 0.1%
32	2	0.1%
29	2	0.1%
28	2	0.1%
27	10	0.3%
26	20	0.6%
25	24	0.7%
24	42	1.3%
23	39	1.2%
22	34	1.0%

membership_expire_date_max
Date

HIGH CORRELATION

Distinct	59
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	25.4 KiB

Minimum	2017-02-01 00:00:00
Maximum	2017-03-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

is_cancel_mean
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	46
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.01397242557

Minimum	0
Maximum	0.5
Zeros	2770
Zeros (%)	85.5%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.09090909091
Maximum	0.5
Range	0.5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.04222331276
Coefficient of variation (CV)	3.021902857
Kurtosis	26.4125793
Mean	0.01397242557
Median Absolute Deviation (MAD)	0
Skewness	4.462107264
Sum	45.27065886
Variance	0.001782808141
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
0	2770	85.5%
0.05555555556	33	1.0%
0.06666666667	33	1.0%
0.07142857143	32	1.0%
0.0625	26	0.8%
0.05882352941	25	0.8%
0.1111111111	23	0.7%
0.09090909091	23	0.7%
0.1	23	0.7%
0.07692307692	22	0.7%
Other values (36)	230	7.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2770	85.5%
0.03448275862	1	< 0.1%
0.03571428571	1	< 0.1%
0.03703703704	6	0.2%
0.03846153846	6	0.2%
0.04	7	0.2%
0.04166666667	6	0.2%
0.04347826087	14	0.4%
0.04545454545	5	0.2%
0.04761904762	17	0.5%

Value	Count	Frequency (%)
0.5	1	< 0.1%
0.4	2	0.1%
0.3333333333	11	0.3%
0.2916666667	1	< 0.1%
0.25	11	0.3%
0.2380952381	1	< 0.1%
0.2222222222	2	0.1%
0.2	11	0.3%
0.1818181818	1	< 0.1%
0.1666666667	20	0.6%

is_cancel_change_flag
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	25.4 KiB

0	2770
1	470

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	3240
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	2770	85.5%
1	470	14.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	2770	85.5%
1	470	14.5%

Most occurring characters

Value	Count	Frequency (%)
0	2770	85.5%
1	470	14.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3240	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2770	85.5%
1	470	14.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	3240	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2770	85.5%
1	470	14.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3240	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2770	85.5%
1	470	14.5%

discount_mean
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	95
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.7715445879

Minimum	-223.5
Maximum	120
Zeros	2911
Zeros (%)	89.8%
Negative	136
Negative (%)	4.2%
Memory size	25.4 KiB

Quantile statistics

Minimum	-223.5
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	8.277777778
Maximum	120
Range	343.5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8.732987399
Coefficient of variation (CV)	11.31883696
Kurtosis	220.6410199
Mean	0.7715445879
Median Absolute Deviation (MAD)	0
Skewness	-4.329118954
Sum	2499.804465
Variance	76.26506891
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2911	89.8%
-6.208333333	18	0.6%
-5.96	15	0.5%
18.625	14	0.4%
-6.47826087	13	0.4%
16.55555556	13	0.4%
14.9	10	0.3%
24.83333333	9	0.3%
9.3125	9	0.3%
49.66666667	9	0.3%
Other values (85)	219	6.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-223.5	1	< 0.1%
-178.8	1	< 0.1%
-40.63636364	1	< 0.1%
-38.86956522	1	< 0.1%
-37.56521739	2	0.1%
-33.86363636	1	< 0.1%
-32.95454545	1	< 0.1%
-28.38095238	1	< 0.1%
-22.35	2	0.1%
-21.42857143	1	< 0.1%

Value	Count	Frequency (%)
120	1	< 0.1%
99.33333333	1	< 0.1%
89.4	1	< 0.1%
74.5	5	0.2%
59.6	2	0.1%
49.66666667	9	0.3%
42.57142857	1	< 0.1%
37.25	9	0.3%
35.05882353	1	< 0.1%
33.11111111	1	< 0.1%

is_discount_mean
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	48
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.009980551507

Minimum	0
Maximum	1
Zeros	3026
Zeros (%)	93.4%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.05882352941
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.05208919576
Coefficient of variation (CV)	5.21906988
Kurtosis	100.3478214
Mean	0.009980551507
Median Absolute Deviation (MAD)	0
Skewness	8.62887225
Sum	32.33698688
Variance	0.002713284315
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
0	3026	93.4%
0.125	14	0.4%
0.1111111111	13	0.4%
0.1	11	0.3%
0.05263157895	10	0.3%
0.0625	9	0.3%
0.05555555556	9	0.3%
0.2	9	0.3%
0.25	9	0.3%
0.3333333333	9	0.3%
Other values (38)	121	3.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3026	93.4%
0.03703703704	2	0.1%
0.03846153846	4	0.1%
0.04	1	< 0.1%
0.04166666667	5	0.2%
0.04347826087	3	0.1%
0.04545454545	5	0.2%
0.04761904762	5	0.2%
0.05	3	0.1%
0.05263157895	10	0.3%

Value	Count	Frequency (%)
1	1	< 0.1%
0.7777777778	1	< 0.1%
0.6666666667	2	0.1%
0.6	1	< 0.1%
0.5294117647	1	< 0.1%
0.5	5	0.2%
0.4615384615	1	< 0.1%
0.4	2	0.1%
0.3461538462	2	0.1%
0.3333333333	9	0.3%

is_discount_max
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	25.4 KiB

0	3026
1	214

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	3240
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	3026	93.4%
1	214	6.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	3026	93.4%
1	214	6.6%

Most occurring characters

Value	Count	Frequency (%)
0	3026	93.4%
1	214	6.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3240	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	3026	93.4%
1	214	6.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	3240	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	3026	93.4%
1	214	6.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3240	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	3026	93.4%
1	214	6.6%

amt_per_day_mean
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	535
Distinct (%)	16.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.072860313

Minimum	0
Maximum	6
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	0
5-th percentile	3.3
Q1	3.3
median	3.333333333
Q3	4.966666667
95-th percentile	5.846153846
Maximum	6
Range	6
Interquartile range (IQR)	1.666666667

Descriptive statistics

Standard deviation	0.9099726283
Coefficient of variation (CV)	0.2234234809
Kurtosis	-0.9085713907
Mean	4.072860313
Median Absolute Deviation (MAD)	0.3622222222
Skewness	0.455419139
Sum	13196.06741
Variance	0.8280501843
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.3	1318	40.7%
4.966666667	584	18.0%
3.3	184	5.7%
6	147	4.5%
4.3	51	1.6%
3.333333333	31	1.0%
4.759722222	19	0.6%
3.725	14	0.4%
5	12	0.4%
4.414814815	12	0.4%
Other values (525)	868	26.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1.324444444	1	< 0.1%
1.655555556	1	< 0.1%
1.777777778	1	< 0.1%
1.986666667	1	< 0.1%
1.9875	1	< 0.1%
1.99875	1	< 0.1%
2	1	< 0.1%
2.15	1	< 0.1%
2.180487805	1	< 0.1%

Value	Count	Frequency (%)
6	147	4.5%
5.916666667	5	0.2%
5.9	3	0.1%
5.875	1	< 0.1%
5.852380952	2	0.1%
5.850997783	1	< 0.1%
5.85	1	< 0.1%
5.846153846	4	0.1%
5.833333333	9	0.3%
5.830555556	1	< 0.1%

membership_duration_mean
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	729
Distinct (%)	22.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.58014865

Minimum	-2395
Maximum	450
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	< 0.1%
Memory size	25.4 KiB

Quantile statistics

Minimum	-2395
5-th percentile	27.25
Q1	29.82954545
median	30.3125
Q3	30.41666667
95-th percentile	45.87958333
Maximum	450
Range	2845
Interquartile range (IQR)	0.5871212121

Descriptive statistics

Standard deviation	51.21829634
Coefficient of variation (CV)	1.5252552
Kurtosis	1572.548189
Mean	33.58014865
Median Absolute Deviation (MAD)	0.3125
Skewness	-31.16723676
Sum	108799.6816
Variance	2623.31388
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	271	8.4%
30.375	141	4.4%
30.33333333	139	4.3%
30.4	99	3.1%
30.28571429	93	2.9%
30.35714286	79	2.4%
30.25	72	2.2%
30.41176471	69	2.1%
30.35294118	62	1.9%
30.30769231	61	1.9%
Other values (719)	2154	66.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2395	1	< 0.1%
3	1	< 0.1%
6.333333333	1	< 0.1%
11.66666667	1	< 0.1%
12	1	< 0.1%
15	1	< 0.1%
15.5	1	< 0.1%
17.4	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%

Value	Count	Frequency (%)
450	1	< 0.1%
434	1	< 0.1%
416	1	< 0.1%
413	4	0.1%
412	1	< 0.1%
411	1	< 0.1%
410	1	< 0.1%
380	2	0.1%
266	1	< 0.1%
221.5	1	< 0.1%

more_than_30_sum
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	25
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.60462963

Minimum	0
Maximum	24
Zeros	428
Zeros (%)	13.2%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	9
95-th percentile	12
Maximum	24
Range	24
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	4.146906008
Coefficient of variation (CV)	0.7399072342
Kurtosis	-0.1578219444
Mean	5.60462963
Median Absolute Deviation (MAD)	4
Skewness	0.4385603041
Sum	18159
Variance	17.19682944
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
0	428	13.2%
1	307	9.5%
9	301	9.3%
7	290	9.0%
5	268	8.3%
2	248	7.7%
10	234	7.2%
6	207	6.4%
3	207	6.4%
8	202	6.2%
Other values (15)	548	16.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	428	13.2%
1	307	9.5%
2	248	7.7%
3	207	6.4%
4	171	5.3%
5	268	8.3%
6	207	6.4%
7	290	9.0%
8	202	6.2%
9	301	9.3%

Value	Count	Frequency (%)
24	1	< 0.1%
23	2	0.1%
22	4	0.1%
21	2	0.1%
20	2	0.1%
19	5	0.2%
18	6	0.2%
17	8	0.2%
16	3	0.1%
15	7	0.2%

num_25
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	2496
Distinct (%)	77.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.064854503

Minimum	0
Maximum	5.087596416
Zeros	134
Zeros (%)	4.1%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.1155245304
Q1	0.5493061543
median	0.9633517265
Q3	1.469801635
95-th percentile	2.369483924
Maximum	5.087596416
Range	5.087596416
Interquartile range (IQR)	0.9204954803

Descriptive statistics

Standard deviation	0.7031103969
Coefficient of variation (CV)	0.6602877378
Kurtosis	1.282059669
Mean	1.064854503
Median Absolute Deviation (MAD)	0.4530927241
Skewness	0.9175319672
Sum	3450.128662
Variance	0.4943642318
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	134	4.1%
0.1732867956	53	1.6%
0.3465735912	34	1.0%
0.4479398727	22	0.7%
0.2746530771	22	0.7%
0.2310490608	19	0.6%
0.6212266684	14	0.4%
0.5493061543	13	0.4%
0.794513464	12	0.4%
0.5198603868	11	0.3%
Other values (2486)	2906	89.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	134	4.1%
0.0433216989	4	0.1%
0.05776226521	2	0.1%
0.07701635361	2	0.1%
0.08664339781	7	0.2%
0.09155102819	3	0.1%
0.09627044201	1	< 0.1%
0.099021025	1	< 0.1%
0.1005898714	1	< 0.1%
0.1032275632	1	< 0.1%

Value	Count	Frequency (%)
5.087596416	1	< 0.1%
4.779123306	1	< 0.1%
4.668941021	1	< 0.1%
4.431880951	1	< 0.1%
4.094344616	1	< 0.1%
4.004874706	1	< 0.1%
3.934511423	1	< 0.1%
3.847038507	1	< 0.1%
3.739151239	1	< 0.1%
3.606147289	1	< 0.1%

num_50
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1468
Distinct (%)	45.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3602947593

Minimum	0
Maximum	4.204692841
Zeros	556
Zeros (%)	17.2%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.08958797157
median	0.2735635042
Q3	0.5163983405
95-th percentile	1.069166541
Maximum	4.204692841
Range	4.204692841
Interquartile range (IQR)	0.4268103689

Descriptive statistics

Standard deviation	0.3708899021
Coefficient of variation (CV)	1.029406905
Kurtosis	8.441922188
Mean	0.3602947593
Median Absolute Deviation (MAD)	0.1988659501
Skewness	2.131618261
Sum	1167.35498
Variance	0.1375593096
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	556	17.2%
0.1732867956	131	4.0%
0.08664339781	67	2.1%
0.3465735912	49	1.5%
0.05776226521	48	1.5%
0.2746530771	42	1.3%
0.1155245304	35	1.1%
0.2310490608	33	1.0%
0.4479398727	30	0.9%
0.3106133342	25	0.8%
Other values (1458)	2224	68.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	556	17.2%
0.01575334556	1	< 0.1%
0.02166084945	2	0.1%
0.02475525625	3	0.1%
0.02567211725	1	< 0.1%
0.0266595073	1	< 0.1%
0.0271822419	1	< 0.1%
0.0288811326	2	0.1%
0.03013683483	1	< 0.1%
0.03150669113	1	< 0.1%

Value	Count	Frequency (%)
4.204692841	1	< 0.1%
2.833213329	1	< 0.1%
2.792538404	1	< 0.1%
2.77258873	1	< 0.1%
2.375086784	1	< 0.1%
2.28217411	1	< 0.1%
2.252919436	1	< 0.1%
2.197224617	1	< 0.1%
2.194118977	1	< 0.1%
2.193020582	1	< 0.1%

num_75
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1060
Distinct (%)	32.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2255322188

Minimum	0
Maximum	2.302585125
Zeros	844
Zeros (%)	26.0%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.1625835672
Q3	0.3219796717
95-th percentile	0.7225929499
Maximum	2.302585125
Range	2.302585125
Interquartile range (IQR)	0.3219796717

Descriptive statistics

Standard deviation	0.2635063827
Coefficient of variation (CV)	1.168375731
Kurtosis	8.076948166
Mean	0.2255322188
Median Absolute Deviation (MAD)	0.1625835598
Skewness	2.251515627
Sum	730.7243652
Variance	0.06943561882
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	844	26.0%
0.1732867956	142	4.4%
0.08664339781	94	2.9%
0.05776226521	63	1.9%
0.2310490608	48	1.5%
0.3465735912	44	1.4%
0.1155245304	44	1.4%
0.2746530771	31	1.0%
0.1493132859	30	0.9%
0.2239699364	30	0.9%
Other values (1050)	1870	57.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	844	26.0%
0.01732867956	1	< 0.1%
0.0192540884	1	< 0.1%
0.01980420575	1	< 0.1%
0.02310490608	1	< 0.1%
0.02475525625	3	0.1%
0.0266595073	1	< 0.1%
0.02772588655	1	< 0.1%
0.0288811326	8	0.2%
0.03051700816	1	< 0.1%

Value	Count	Frequency (%)
2.302585125	1	< 0.1%
2.197224617	1	< 0.1%
2.144054174	1	< 0.1%
1.945910215	1	< 0.1%
1.935600519	1	< 0.1%
1.912810326	1	< 0.1%
1.83605957	1	< 0.1%
1.791759491	1	< 0.1%
1.752498507	1	< 0.1%
1.66610229	1	< 0.1%

num_985
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1082
Distinct (%)	33.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2363214344

Minimum	0
Maximum	2.224787235
Zeros	815
Zeros (%)	25.2%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.1732867956
Q3	0.3343475312
95-th percentile	0.7880127043
Maximum	2.224787235
Range	2.224787235
Interquartile range (IQR)	0.3343475312

Descriptive statistics

Standard deviation	0.2739073336
Coefficient of variation (CV)	1.159045696
Kurtosis	6.389976501
Mean	0.2363214344
Median Absolute Deviation (MAD)	0.1629528999
Skewness	2.102514029
Sum	765.6814575
Variance	0.07502523065
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	815	25.2%
0.1732867956	152	4.7%
0.08664339781	90	2.8%
0.05776226521	60	1.9%
0.1155245304	54	1.7%
0.2746530771	45	1.4%
0.2310490608	41	1.3%
0.3465735912	40	1.2%
0.1373265386	27	0.8%
0.09155102819	23	0.7%
Other values (1072)	1893	58.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	815	25.2%
0.01575334556	1	< 0.1%
0.01732867956	1	< 0.1%
0.0192540884	2	0.1%
0.02166084945	3	0.1%
0.02475525625	6	0.2%
0.0288811326	11	0.3%
0.03013683483	1	< 0.1%
0.03051700816	1	< 0.1%
0.03138892353	1	< 0.1%

Value	Count	Frequency (%)
2.224787235	1	< 0.1%
2.189838648	1	< 0.1%
2.020660639	1	< 0.1%
1.791759491	1	< 0.1%
1.754158974	1	< 0.1%
1.704551458	1	< 0.1%
1.695865512	1	< 0.1%
1.691724658	1	< 0.1%
1.678399086	1	< 0.1%
1.612094045	1	< 0.1%

num_100
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	3035
Distinct (%)	93.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.408321619

Minimum	0
Maximum	5.905887604
Zeros	41
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.8664339781
Q1	1.884092122
median	2.439326286
Q3	2.966488123
95-th percentile	3.773670042
Maximum	5.905887604
Range	5.905887604
Interquartile range (IQR)	1.082396001

Descriptive statistics

Standard deviation	0.8759378195
Coefficient of variation (CV)	0.3637129664
Kurtosis	0.4219321609
Mean	2.408321619
Median Absolute Deviation (MAD)	0.5415901542
Skewness	-0.139826104
Sum	7802.961914
Variance	0.767267108
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	41	1.3%
0.6931471825	12	0.4%
0.3465735912	8	0.2%
0.5198603868	7	0.2%
2.079441547	6	0.2%
0.8958797455	6	0.2%
0.5493061543	5	0.2%
0.8664339781	5	0.2%
1.471526027	5	0.2%
1.343819618	5	0.2%
Other values (3025)	3140	96.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	41	1.3%
0.1373265386	1	< 0.1%
0.1732867956	4	0.1%
0.2310490608	2	0.1%
0.2484906614	1	< 0.1%
0.2746530771	3	0.1%
0.2986265719	1	< 0.1%
0.3465735912	8	0.2%
0.3662041128	2	0.1%
0.3891820312	1	< 0.1%

Value	Count	Frequency (%)
5.905887604	1	< 0.1%
5.331583023	1	< 0.1%
5.180026054	1	< 0.1%
5.068177223	1	< 0.1%
5.064611435	1	< 0.1%
5.061811447	1	< 0.1%
5.027421474	1	< 0.1%
5.01904726	1	< 0.1%
4.975762367	1	< 0.1%
4.912617207	1	< 0.1%

num_unq
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3107
Distinct (%)	95.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.625793695

Minimum	0
Maximum	5.407171726
Zeros	11
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1.328061116
Q1	2.183980525
median	2.661792874
Q3	3.111875474
95-th percentile	3.781433177
Maximum	5.407171726
Range	5.407171726
Interquartile range (IQR)	0.9278949499

Descriptive statistics

Standard deviation	0.7468746305
Coefficient of variation (CV)	0.2844376564
Kurtosis	0.7164651752
Mean	2.625793695
Median Absolute Deviation (MAD)	0.4640641212
Skewness	-0.2901935875
Sum	8507.571289
Variance	0.557821691
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11	0.3%
0.6931471825	8	0.2%
1.791759491	8	0.2%
0.3465735912	7	0.2%
1.098612309	7	0.2%
2.302585125	5	0.2%
1.039720774	5	0.2%
1.059351325	4	0.1%
0.6212266684	4	0.1%
1.902217627	4	0.1%
Other values (3097)	3177	98.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11	0.3%
0.1732867956	2	0.1%
0.2746530771	1	< 0.1%
0.3465735912	7	0.2%
0.3662041128	1	< 0.1%
0.4315260947	1	< 0.1%
0.4479398727	2	0.1%
0.4620981216	2	0.1%
0.4864775538	1	< 0.1%
0.5296756625	1	< 0.1%

Value	Count	Frequency (%)
5.407171726	1	< 0.1%
5.147494316	1	< 0.1%
5.002599239	1	< 0.1%
4.908172607	1	< 0.1%
4.865320206	1	< 0.1%
4.84916687	1	< 0.1%
4.815023422	1	< 0.1%
4.782802582	1	< 0.1%
4.753828049	1	< 0.1%
4.733560562	1	< 0.1%

total_secs
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	725
Distinct (%)	22.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.03125

Minimum	2.455078125
Maximum	10.7734375
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	2.455078125
5-th percentile	6.601367188
Q1	7.56640625
median	8.0625
Q3	8.580078125
95-th percentile	9.328515625
Maximum	10.7734375
Range	8.318359375
Interquartile range (IQR)	1.013671875

Descriptive statistics

Standard deviation	0.87890625
Coefficient of variation (CV)	0.1094360352
Kurtosis	2.97265625
Mean	8.03125
Median Absolute Deviation (MAD)	0.5078125
Skewness	-0.7622070312
Sum	26016
Variance	0.7724609375
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.015625	19	0.6%
8.234375	18	0.6%
8.0625	18	0.6%
8.171875	18	0.6%
8.6796875	17	0.5%
8.125	17	0.5%
8.140625	17	0.5%
8.3359375	17	0.5%
8.390625	17	0.5%
8.0546875	17	0.5%
Other values (715)	3065	94.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.455078125	1	< 0.1%
2.849609375	1	< 0.1%
2.861328125	1	< 0.1%
2.9765625	1	< 0.1%
3.03515625	1	< 0.1%
3.8203125	1	< 0.1%
4.0703125	1	< 0.1%
4.08984375	1	< 0.1%
4.21484375	1	< 0.1%
4.36328125	1	< 0.1%

Value	Count	Frequency (%)
10.7734375	1	< 0.1%
10.578125	1	< 0.1%
10.546875	1	< 0.1%
10.5390625	1	< 0.1%
10.5234375	1	< 0.1%
10.4765625	1	< 0.1%
10.4609375	1	< 0.1%
10.40625	1	< 0.1%
10.390625	1	< 0.1%
10.375	1	< 0.1%

login_freq
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.2

Minimum	1
Maximum	60
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	6
median	12
Q3	21
95-th percentile	36.05
Maximum	60
Range	59
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	11.47972157
Coefficient of variation (CV)	0.7552448404
Kurtosis	0.6164804356
Mean	15.2
Median Absolute Deviation (MAD)	8
Skewness	1.05163755
Sum	49248
Variance	131.7840074
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	522	16.1%
8	389	12.0%
12	382	11.8%
16	238	7.3%
20	200	6.2%
24	197	6.1%
28	151	4.7%
3	146	4.5%
32	117	3.6%
6	98	3.0%
Other values (43)	800	24.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	50	1.5%
2	49	1.5%
3	146	4.5%
4	522	16.1%
5	30	0.9%
6	98	3.0%
7	20	0.6%
8	389	12.0%
9	71	2.2%
10	15	0.5%

Value	Count	Frequency (%)
60	2	0.1%
56	7	0.2%
54	1	< 0.1%
52	18	0.6%
51	1	< 0.1%
49	2	0.1%
48	26	0.8%
47	3	0.1%
45	1	< 0.1%
44	39	1.2%

last_login
Date

Distinct	368
Distinct (%)	11.4%
Missing	0
Missing (%)	0.0%
Memory size	25.4 KiB

Minimum	2015-02-19 00:00:00
Maximum	2017-02-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

registration_duration
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	629
Distinct (%)	19.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	405.6981481

Minimum	22
Maximum	819
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.4 KiB

Quantile statistics

Minimum	22
5-th percentile	90
Q1	243
median	424
Q3	547
95-th percentile	728.05
Maximum	819
Range	797
Interquartile range (IQR)	304

Descriptive statistics

Standard deviation	187.5153054
Coefficient of variation (CV)	0.4622039963
Kurtosis	-0.7962752704
Mean	405.6981481
Median Absolute Deviation (MAD)	149
Skewness	-0.01974052938
Sum	1314462
Variance	35161.98975
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
425	80	2.5%
517	79	2.4%
516	69	2.1%
486	68	2.1%
394	66	2.0%
547	62	1.9%
242	61	1.9%
424	57	1.8%
211	56	1.7%
578	56	1.7%
Other values (619)	2586	79.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
22	1	< 0.1%
27	1	< 0.1%
30	4	0.1%
31	1	< 0.1%
33	1	< 0.1%
34	1	< 0.1%
35	1	< 0.1%
56	1	< 0.1%
58	31	1.0%
59	5	0.2%

Value	Count	Frequency (%)
819	1	< 0.1%
814	1	< 0.1%
813	1	< 0.1%
810	3	0.1%
809	1	< 0.1%
806	1	< 0.1%
805	2	0.1%
803	2	0.1%
801	1	< 0.1%
799	3	0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	msno	city	bd	gender	registered_via	registration_init_time	is_churn	total_payment_channels	change_in_payment_methods	payment_plan_days_mean	change_in_plan	plan_list_price_mean	actual_amount_paid_mean	is_auto_renew_mean	is_autorenew_change_flag	transaction_date_min	transaction_date_max	total_transactions	membership_expire_date_max	is_cancel_mean	is_cancel_change_flag	amt_per_day_mean	membership_duration_mean	more_than_30_sum	num_25	num_50	num_75	num_985	num_100	num_unq	total_secs	login_freq	last_login	registration_duration
0	252737	T4TLe/jOIP0/Bg9kOKR3rd19XVZDIHlVzvS3DhpweIk=	1	6.3	2	4	2016-05-22	1	9	2	27.444444	2	132.444444	132.444444	0.000000	0	2016-05-23	2017-01-04	9	2017-02-03	0.000000	0	4.414815	41.222222	6	1.013038	0.568968	0.198042	0.099021	1.223618	2.076368	7.078125	14	2017-02-25	257
1	80833	3twUh3ugQEnQyGAyOxT4uPhpMht2EPW1vl6/k7J+RdI=	8	26.0	1	3	2015-04-11	1	15	1	41.000000	2	198.666667	198.666667	0.000000	0	2015-04-11	2016-08-05	15	2017-02-17	0.000000	0	4.941197	41.533333	2	1.583790	0.359393	0.337993	0.537676	2.452048	3.038424	8.257812	44	2017-01-21	678
2	89564	/1X44AKG3S5AoBAJeokIkqLvgRaz+h5ElPncLqWnWys=	1	6.3	2	7	2015-12-01	0	14	1	30.000000	1	149.000000	149.000000	1.000000	1	2015-12-01	2017-02-28	14	2017-03-31	0.000000	0	4.966667	30.285714	7	1.382377	0.353117	0.269348	0.440205	3.848993	3.863208	9.406250	27	2017-01-27	486
3	141070	1Ufg2Ep/dzom8G0hN+0UWbmxpRPFrGt4D4Vh2yd4pOA=	1	6.3	2	7	2016-09-10	0	7	1	30.000000	1	142.000000	142.000000	1.000000	1	2016-09-10	2017-02-03	7	2017-03-02	0.142857	1	4.733333	25.571429	3	1.378806	0.207076	0.057762	0.057762	1.865789	2.257427	7.589844	12	2017-01-19	173
4	182169	ZozytlgZZhHBVCTHGug8CxREhiV9QpS+TJ5e+z06gVA=	1	6.3	2	7	2017-01-06	0	2	1	30.000000	1	99.000000	99.000000	1.000000	1	2017-01-06	2017-02-05	2	2017-03-05	0.000000	0	3.300000	29.000000	0	1.163490	0.346574	0.000000	0.274653	0.866434	1.599232	6.941406	4	2017-01-26	58
5	30877	fsnsbXZaA/6BEIkHAEXt3yv0IKmO2BT7X6OVSryjLwE=	18	36.0	1	4	2015-12-21	0	15	1	30.000000	1	149.000000	149.000000	1.000000	1	2015-12-22	2017-02-22	15	2017-03-23	0.000000	0	4.966667	31.400000	13	0.762862	0.221265	0.279372	0.246718	3.508522	3.509402	9.062500	36	2017-02-27	458
6	178732	Pu+GJ7D/z/RdQdtkEC1FliAwgfqf4Lj2R+Yy8zpxIPI=	13	21.0	1	4	2016-04-18	0	9	2	30.000000	1	149.000000	149.000000	0.777778	1	2016-05-13	2017-02-08	9	2017-03-07	0.000000	0	4.966667	29.444444	0	1.986556	0.822406	0.374467	0.000000	0.995693	2.659642	7.160156	8	2016-12-28	323
7	106440	4qn9IK9A4x98g5rvJzA/zs22i/cXKVnH2UxKIIohsmE=	4	19.0	0	7	2016-05-27	0	10	1	30.000000	1	99.000000	99.000000	1.000000	1	2016-05-27	2017-02-27	10	2017-03-27	0.000000	0	3.300000	30.400000	6	1.577559	0.588908	0.294268	0.357281	2.165143	2.795527	7.910156	22	2017-02-28	304
8	234719	7Ch66cFMKjzoFmwEael1cZmL96xEXu1deuaISvbLeU4=	1	6.3	2	7	2016-07-14	0	8	1	30.000000	1	99.000000	99.000000	1.000000	1	2016-07-14	2017-02-14	8	2017-03-14	0.000000	0	3.300000	30.375000	5	2.077086	0.361296	0.173287	0.000000	1.612202	2.362854	7.074219	8	2017-02-06	243
9	274386	5dpAfmav4ClRi5GKyLvGya+izdDXwwr/4OZt9gxmDlU=	1	6.3	2	4	2015-10-18	0	4	1	71.250000	2	335.250000	335.250000	0.000000	0	2016-05-20	2017-02-04	4	2017-03-06	0.000000	0	4.871154	71.250000	1	0.403842	0.216608	0.068663	0.169253	2.933867	3.001538	8.445312	16	2016-12-25	505

Last rows

	df_index	msno	city	bd	gender	registered_via	registration_init_time	total_payment_channels	change_in_payment_methods	payment_plan_days_mean	change_in_plan	plan_list_price_mean	actual_amount_paid_mean	is_auto_renew_mean	is_autorenew_change_flag	transaction_date_min	transaction_date_max	total_transactions	membership_expire_date_max	is_cancel_mean	is_cancel_change_flag	discount_mean	amt_per_day_mean	membership_duration_mean	more_than_30_sum	num_25	num_50	num_75	num_985	num_100	num_unq	total_secs	login_freq	last_login	registration_duration
3230	187413	79Q/WeLodGSQlPUcu6wsDyjVJGnSPXv6RMc9wGcTiR8=	1	6.3	2	7	2016-07-21	8	1	30.000000	1	99.000000	99.000000	1.00	1	2016-07-21	2017-02-21	8	2017-03-21	0.000000	0	0.000000	3.300000	30.375000	5	0.668388	0.000000	0.223970	0.086643	2.241992	2.597821	7.785156	8	2017-01-24	243
3231	304085	tgeVcKKWT6J9gkjx2JU55hxxUH88+LEFoQH86/cZ1D8=	1	6.3	2	7	2015-08-24	19	1	30.000000	1	99.000000	99.000000	1.00	1	2015-08-24	2017-02-24	19	2017-03-24	0.000000	0	0.000000	3.300000	30.421053	11	0.963329	0.447496	0.415871	0.420436	2.544532	2.918861	8.195312	28	2017-01-24	578
3232	322144	MGaWfjFD/r30hDkROFyUVWi855UH0ztytdvDL5V7Pvk=	1	6.3	2	7	2015-08-15	19	1	30.000000	1	99.000000	99.000000	1.00	1	2015-08-15	2017-02-15	19	2017-03-15	0.000000	0	0.000000	3.300000	30.421053	11	0.510015	0.205902	0.057762	0.028881	2.798397	2.899035	8.281250	24	2017-01-02	578
3233	263776	fQJki8ybPbMCQNFQPNBW+sFLR8+pBELeX7rlkqrTLbc=	1	6.3	2	4	2016-06-11	4	2	24.250000	2	96.750000	96.750000	0.75	1	2016-11-18	2017-02-13	4	2017-03-12	0.000000	0	0.000000	3.225000	23.500000	0	0.274653	0.000000	0.000000	0.000000	2.769765	2.557477	8.171875	4	2017-02-02	274
3234	288974	vg+QL04sOCSObeXU69EJiHO2NImLRK67ahyuBpVzFeA=	1	6.3	2	7	2016-10-20	5	1	30.000000	1	99.000000	99.000000	1.00	1	2016-10-20	2017-02-20	5	2017-03-20	0.000000	0	0.000000	3.300000	30.200000	3	1.919466	0.748933	0.173287	0.519860	2.692794	3.100821	8.523438	4	2017-01-19	151
3235	86597	GGYWYQvviAQ9W94VQflD8wEyb6WKNExntEJipz6mv8g=	6	35.0	0	7	2015-04-11	23	1	28.695652	2	132.956522	138.565217	1.00	1	2015-04-11	2017-02-11	23	2017-03-11	0.000000	0	-5.608696	4.431884	30.434783	13	1.293096	0.402168	0.385608	0.350725	4.184368	4.235391	9.773438	56	2017-02-03	700
3236	207550	5sSNrAqwo38OR9C+ONc8KIw87taIUG/qmCfT/UDGb6E=	5	6.3	2	4	2016-10-08	6	2	30.000000	1	174.833333	174.833333	1.00	1	2016-10-09	2017-02-13	6	2017-03-12	0.166667	1	0.000000	5.827778	25.833333	4	1.674776	0.807731	0.587438	0.374984	2.208150	2.763800	8.070312	12	2017-02-13	155
3237	92226	15vWvbCMoL85Av7HzcT6j2dPhle8xr9Hb64NwqrlcUU=	1	6.3	2	7	2016-03-27	13	1	30.000000	1	147.461538	147.461538	1.00	1	2016-03-27	2017-02-05	13	2017-03-04	0.076923	1	0.000000	4.915385	27.923077	6	0.687469	0.374777	0.144519	0.124245	2.058531	2.280118	7.636719	20	2017-02-17	342
3238	81542	RTPKmf59dlNdzpxKu/qrtOqDQ74He06Xf5BC/rMz3DU=	1	6.3	2	7	2015-09-25	18	1	30.000000	1	99.000000	99.000000	1.00	1	2015-09-25	2017-02-25	18	2017-03-25	0.000000	0	0.000000	3.300000	30.388889	10	1.699414	0.404618	0.363569	0.612881	2.202865	2.791239	8.015625	16	2016-12-26	547
3239	319970	3WzQnhLLIR6Rt/DEYHEsgjxiJHoTudo5SXkgftKbyc0=	1	6.3	2	7	2016-02-06	13	1	30.000000	1	99.000000	99.000000	1.00	1	2016-02-06	2017-02-06	13	2017-03-06	0.000000	0	0.000000	3.300000	30.307692	7	0.384555	0.046210	0.092420	0.000000	2.497438	1.816807	8.000000	15	2017-02-14	394

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Math Symbol

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script